LOAD DATA
TRUNCATE 
INTO TABLE gex_bde_amt_goc_tb
TRAILING NULLCOLS 
(line_no                SEQUENCE(MAX)
,date_eff		POSITION(1:11)		"TO_DATE(:date_eff,'YYYY/MM/DD')"                      
,date_maj		POSITION(12:22)		"TO_DATE(:date_maj,'YYYY/MM/DD')"                      
,cd_portefeuille	POSITION(23:38)		CHAR 
,cd_division		POSITION(39:50) 	CHAR
,freq_prod		POSITION(51:60) 	CHAR    
,type_montant		POSITION(61:81)		CHAR
,devise 		POSITION(82:97) 	CHAR
,montant		POSITION(98:116)	"TO_NUMBER(:montant,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,montant_cad		POSITION(117:135)	"TO_NUMBER(:montant_cad,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,provenance 		POSITION(136:145)	CHAR
)                                                                                                      
